unit U_dm_principal;

interface

uses
  System.SysUtils, System.Classes, Data.DBXFirebird, Data.DB, Data.SqlExpr,
  Data.FMTBcd, Datasnap.DBClient, Datasnap.Provider;

type
  Tdm_principal = class(TDataModule)
    sql_con: TSQLConnection;
    qry_usuario: TSQLDataSet;
    dsp_usuario: TDataSetProvider;
    cds_usuario: TClientDataSet;
    ds_usuario: TDataSource;
    qry_usuarioUSER_ID: TIntegerField;
    qry_usuarioUSER_NOME: TStringField;
    qry_usuarioUSER_LOGIN: TStringField;
    qry_usuarioUSER_SENHA: TStringField;
    qry_usuarioUSER_TIPO: TIntegerField;
    cds_usuarioUSER_ID: TIntegerField;
    cds_usuarioUSER_NOME: TStringField;
    cds_usuarioUSER_LOGIN: TStringField;
    cds_usuarioUSER_SENHA: TStringField;
    cds_usuarioUSER_TIPO: TIntegerField;
    sq_generators: TSQLQuery;
    qry_aluno: TSQLDataSet;
    dsp_aluno: TDataSetProvider;
    cds_aluno: TClientDataSet;
    ds_aluno: TDataSource;
    qry_alunoALU_ALERGIA: TMemoField;
    qry_alunoALU_BAIRRO: TStringField;
    qry_alunoALU_BAIRRO1: TStringField;
    qry_alunoALU_BAIRRO2: TStringField;
    qry_alunoALU_CIDADE: TStringField;
    qry_alunoALU_CIDADE1: TStringField;
    qry_alunoALU_CIDADE2: TStringField;
    qry_alunoALU_DATA_DESLIGAMENTO: TDateField;
    qry_alunoALU_DATA_MATRICULA: TDateField;
    qry_alunoALU_DATA_NASC: TDateField;
    qry_alunoALU_DEFICIENCAS: TMemoField;
    qry_alunoALU_DOENCA: TMemoField;
    qry_alunoALU_DOENCA_CONTAGIOSA: TMemoField;
    qry_alunoALU_ENDERECO: TStringField;
    qry_alunoALU_ENDERECO1: TStringField;
    qry_alunoALU_ENDERECO2: TStringField;
    qry_alunoALU_FKTUR_ID: TIntegerField;
    qry_alunoALU_FOTO: TStringField;
    qry_alunoALU_GRAU_PARENTESCO1: TStringField;
    qry_alunoALU_GRAU_PARENTESCO2: TStringField;
    qry_alunoALU_ID: TIntegerField;
    qry_alunoALU_NACIONALIDADE: TStringField;
    qry_alunoALU_NATURALIDADE: TStringField;
    qry_alunoALU_NOME: TStringField;
    qry_alunoALU_NOME_MAE: TStringField;
    qry_alunoALU_NOME_PAI: TStringField;
    qry_alunoALU_NOME_PLANO_SAUDE: TStringField;
    qry_alunoALU_NOME_RESPONSAVEL1: TStringField;
    qry_alunoALU_NOME_RESPONSAVEL2: TStringField;
    qry_alunoALU_NUMERO: TStringField;
    qry_alunoALU_NUMERO_CARTERINHA: TStringField;
    qry_alunoALU_NUMERO_MATRICULA: TIntegerField;
    qry_alunoALU_NUMERO1: TStringField;
    qry_alunoALU_NUMERO2: TStringField;
    qry_alunoALU_OBSERVACOES: TMemoField;
    qry_alunoALU_ORGAO_EMISSOR: TStringField;
    qry_alunoALU_POSSUI_ALERGIA: TStringField;
    qry_alunoALU_RG: TIntegerField;
    qry_alunoALU_SEXO: TStringField;
    qry_alunoALU_SITUACAO: TStringField;
    qry_alunoALU_TELEFONE: TStringField;
    qry_alunoALU_TELEFONE_SAUDE: TStringField;
    qry_alunoALU_TELEFONE1: TStringField;
    qry_alunoALU_TELEFONE2: TStringField;
    qry_alunoALU_TIPO_SANGUINEO: TStringField;
    qry_alunoALU_VACINAS: TMemoField;
    cds_alunoALU_ALERGIA: TMemoField;
    cds_alunoALU_BAIRRO: TStringField;
    cds_alunoALU_BAIRRO1: TStringField;
    cds_alunoALU_BAIRRO2: TStringField;
    cds_alunoALU_CIDADE: TStringField;
    cds_alunoALU_CIDADE1: TStringField;
    cds_alunoALU_CIDADE2: TStringField;
    cds_alunoALU_DATA_DESLIGAMENTO: TDateField;
    cds_alunoALU_DATA_MATRICULA: TDateField;
    cds_alunoALU_DATA_NASC: TDateField;
    cds_alunoALU_DEFICIENCAS: TMemoField;
    cds_alunoALU_DOENCA: TMemoField;
    cds_alunoALU_DOENCA_CONTAGIOSA: TMemoField;
    cds_alunoALU_ENDERECO: TStringField;
    cds_alunoALU_ENDERECO1: TStringField;
    cds_alunoALU_ENDERECO2: TStringField;
    cds_alunoALU_FKTUR_ID: TIntegerField;
    cds_alunoALU_FOTO: TStringField;
    cds_alunoALU_GRAU_PARENTESCO1: TStringField;
    cds_alunoALU_GRAU_PARENTESCO2: TStringField;
    cds_alunoALU_ID: TIntegerField;
    cds_alunoALU_NACIONALIDADE: TStringField;
    cds_alunoALU_NATURALIDADE: TStringField;
    cds_alunoALU_NOME: TStringField;
    cds_alunoALU_NOME_MAE: TStringField;
    cds_alunoALU_NOME_PAI: TStringField;
    cds_alunoALU_NOME_PLANO_SAUDE: TStringField;
    cds_alunoALU_NOME_RESPONSAVEL1: TStringField;
    cds_alunoALU_NOME_RESPONSAVEL2: TStringField;
    cds_alunoALU_NUMERO: TStringField;
    cds_alunoALU_NUMERO_CARTERINHA: TStringField;
    cds_alunoALU_NUMERO_MATRICULA: TIntegerField;
    cds_alunoALU_NUMERO1: TStringField;
    cds_alunoALU_NUMERO2: TStringField;
    cds_alunoALU_OBSERVACOES: TMemoField;
    cds_alunoALU_ORGAO_EMISSOR: TStringField;
    cds_alunoALU_POSSUI_ALERGIA: TStringField;
    cds_alunoALU_RG: TIntegerField;
    cds_alunoALU_SEXO: TStringField;
    cds_alunoALU_SITUACAO: TStringField;
    cds_alunoALU_TELEFONE: TStringField;
    cds_alunoALU_TELEFONE_SAUDE: TStringField;
    cds_alunoALU_TELEFONE1: TStringField;
    cds_alunoALU_TELEFONE2: TStringField;
    cds_alunoALU_TIPO_SANGUINEO: TStringField;
    cds_alunoALU_VACINAS: TMemoField;
    qry_busca_aluno: TSQLDataSet;
    MemoField1: TMemoField;
    StringField1: TStringField;
    StringField2: TStringField;
    StringField3: TStringField;
    StringField4: TStringField;
    StringField5: TStringField;
    StringField6: TStringField;
    DateField1: TDateField;
    DateField2: TDateField;
    DateField3: TDateField;
    MemoField2: TMemoField;
    MemoField3: TMemoField;
    MemoField4: TMemoField;
    StringField7: TStringField;
    StringField8: TStringField;
    StringField9: TStringField;
    IntegerField1: TIntegerField;
    StringField10: TStringField;
    StringField11: TStringField;
    StringField12: TStringField;
    IntegerField2: TIntegerField;
    StringField13: TStringField;
    StringField14: TStringField;
    StringField15: TStringField;
    StringField16: TStringField;
    StringField17: TStringField;
    StringField18: TStringField;
    StringField19: TStringField;
    StringField20: TStringField;
    StringField21: TStringField;
    StringField22: TStringField;
    IntegerField3: TIntegerField;
    StringField23: TStringField;
    StringField24: TStringField;
    MemoField5: TMemoField;
    StringField25: TStringField;
    StringField26: TStringField;
    IntegerField4: TIntegerField;
    StringField27: TStringField;
    StringField28: TStringField;
    StringField29: TStringField;
    StringField30: TStringField;
    StringField31: TStringField;
    StringField32: TStringField;
    StringField33: TStringField;
    MemoField6: TMemoField;
    dsp_busca_aluno: TDataSetProvider;
    cds_busca_aluno: TClientDataSet;
    MemoField7: TMemoField;
    StringField34: TStringField;
    StringField35: TStringField;
    StringField36: TStringField;
    StringField37: TStringField;
    StringField38: TStringField;
    StringField39: TStringField;
    DateField4: TDateField;
    DateField5: TDateField;
    DateField6: TDateField;
    MemoField8: TMemoField;
    MemoField9: TMemoField;
    MemoField10: TMemoField;
    StringField40: TStringField;
    StringField41: TStringField;
    StringField42: TStringField;
    IntegerField5: TIntegerField;
    StringField43: TStringField;
    StringField44: TStringField;
    StringField45: TStringField;
    IntegerField6: TIntegerField;
    StringField46: TStringField;
    StringField47: TStringField;
    StringField48: TStringField;
    StringField49: TStringField;
    StringField50: TStringField;
    StringField51: TStringField;
    StringField52: TStringField;
    StringField53: TStringField;
    StringField54: TStringField;
    StringField55: TStringField;
    IntegerField7: TIntegerField;
    StringField56: TStringField;
    StringField57: TStringField;
    MemoField11: TMemoField;
    StringField58: TStringField;
    StringField59: TStringField;
    IntegerField8: TIntegerField;
    StringField60: TStringField;
    StringField61: TStringField;
    StringField62: TStringField;
    StringField63: TStringField;
    StringField64: TStringField;
    StringField65: TStringField;
    StringField66: TStringField;
    MemoField12: TMemoField;
    ds_busca_aluno: TDataSource;
    qry_turma: TSQLDataSet;
    cds_turma: TClientDataSet;
    ds_turma: TDataSource;
    dsp_turma: TDataSetProvider;
    qry_turmaSQLDataSet: TSQLDataSet;
    qry_turmaMemoField: TMemoField;
    qry_turmaStringField: TStringField;
    qry_turmaStringField2: TStringField;
    qry_turmaStringField3: TStringField;
    qry_turmaStringField4: TStringField;
    qry_turmaStringField5: TStringField;
    qry_turmaStringField6: TStringField;
    qry_turmaDateField: TDateField;
    qry_turmaDateField2: TDateField;
    qry_turmaDateField3: TDateField;
    qry_turmaMemoField2: TMemoField;
    qry_turmaMemoField3: TMemoField;
    qry_turmaMemoField4: TMemoField;
    qry_turmaStringField7: TStringField;
    qry_turmaStringField8: TStringField;
    qry_turmaStringField9: TStringField;
    qry_turmaIntegerField: TIntegerField;
    qry_turmaStringField10: TStringField;
    qry_turmaStringField11: TStringField;
    qry_turmaStringField12: TStringField;
    qry_turmaIntegerField2: TIntegerField;
    qry_turmaStringField13: TStringField;
    qry_turmaStringField14: TStringField;
    qry_turmaStringField15: TStringField;
    qry_turmaStringField16: TStringField;
    qry_turmaStringField17: TStringField;
    qry_turmaStringField18: TStringField;
    qry_turmaStringField19: TStringField;
    qry_turmaStringField20: TStringField;
    qry_turmaStringField21: TStringField;
    qry_turmaStringField22: TStringField;
    qry_turmaIntegerField3: TIntegerField;
    qry_turmaStringField23: TStringField;
    qry_turmaStringField24: TStringField;
    qry_turmaMemoField5: TMemoField;
    qry_turmaStringField25: TStringField;
    qry_turmaStringField26: TStringField;
    qry_turmaIntegerField4: TIntegerField;
    qry_turmaStringField27: TStringField;
    qry_turmaStringField28: TStringField;
    qry_turmaStringField29: TStringField;
    qry_turmaStringField30: TStringField;
    qry_turmaStringField31: TStringField;
    qry_turmaStringField32: TStringField;
    qry_turmaStringField33: TStringField;
    qry_turmaMemoField6: TMemoField;
    qry_turmaDataSetProvider: TDataSetProvider;
    qry_turmaClientDataSet: TClientDataSet;
    qry_turmaMemoField7: TMemoField;
    qry_turmaStringField34: TStringField;
    qry_turmaStringField35: TStringField;
    qry_turmaStringField36: TStringField;
    qry_turmaStringField37: TStringField;
    qry_turmaStringField38: TStringField;
    qry_turmaStringField39: TStringField;
    qry_turmaDateField4: TDateField;
    qry_turmaDateField5: TDateField;
    qry_turmaDateField6: TDateField;
    qry_turmaMemoField8: TMemoField;
    qry_turmaMemoField9: TMemoField;
    qry_turmaMemoField10: TMemoField;
    qry_turmaStringField40: TStringField;
    qry_turmaStringField41: TStringField;
    qry_turmaStringField42: TStringField;
    qry_turmaIntegerField5: TIntegerField;
    qry_turmaStringField43: TStringField;
    qry_turmaStringField44: TStringField;
    qry_turmaStringField45: TStringField;
    qry_turmaIntegerField6: TIntegerField;
    qry_turmaStringField46: TStringField;
    qry_turmaStringField47: TStringField;
    qry_turmaStringField48: TStringField;
    qry_turmaStringField49: TStringField;
    qry_turmaStringField50: TStringField;
    qry_turmaStringField51: TStringField;
    qry_turmaStringField52: TStringField;
    qry_turmaStringField53: TStringField;
    qry_turmaStringField54: TStringField;
    qry_turmaStringField55: TStringField;
    qry_turmaIntegerField7: TIntegerField;
    qry_turmaStringField56: TStringField;
    qry_turmaStringField57: TStringField;
    qry_turmaMemoField11: TMemoField;
    qry_turmaStringField58: TStringField;
    qry_turmaStringField59: TStringField;
    qry_turmaIntegerField8: TIntegerField;
    qry_turmaStringField60: TStringField;
    qry_turmaStringField61: TStringField;
    qry_turmaStringField62: TStringField;
    qry_turmaStringField63: TStringField;
    qry_turmaStringField64: TStringField;
    qry_turmaStringField65: TStringField;
    qry_turmaStringField66: TStringField;
    qry_turmaMemoField12: TMemoField;
    ds_turmaDataSource: TDataSource;
    qry_turmaTUR_ANO: TStringField;
    qry_turmaTUR_FKALU_ID: TIntegerField;
    qry_turmaTUR_ID: TIntegerField;
    qry_turmaTUR_PERIODO: TStringField;
    qry_turmaTUR_TURMA: TStringField;
    cds_turmaTUR_ANO: TStringField;
    cds_turmaTUR_FKALU_ID: TIntegerField;
    cds_turmaTUR_ID: TIntegerField;
    cds_turmaTUR_PERIODO: TStringField;
    cds_turmaTUR_TURMA: TStringField;
    qry_turmaTUR_NOMEALUNO: TStringField;
    cds_turmaTUR_NOMEALUNO: TStringField;
    procedure sql_conBeforeConnect(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dm_principal: Tdm_principal;

implementation

uses
  Vcl.Forms;

{%CLASSGROUP 'Vcl.Controls.TControl'}

{$R *.dfm}

procedure Tdm_principal.sql_conBeforeConnect(Sender: TObject);
begin
SQL_Con.LoadParamsFromIniFile(ExtractFilePath(Application.ExeName)+ 'dbxconnections.ini');
end;

end.
